1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Controllers
13 {
14 class CauHinhHeThongCtrl
15 {
16
17 // Method Add
18 public static int InsertCauHinhHeThong(string _KhoaChinh, string _GiaTri, string _TrangThai, string _GhiChu)
19 {
20 try
21 {
22 Models.CauHinhHeThongMod cauHinhHeThong = new Models.CauHinhHeThongMod( _KhoaChinh, _GiaTri, _TrangThai, _GhiChu);
23 return cauHinhHeThong.InsertCauHinhHeThong();
24 }
25 catch
26 {
27 return 0;
28 }
29 }
30
31 // Method Update
32 public static int UpdateCauHinhHeThong(string _KhoaChinh, string _GiaTri, string _TrangThai, string _GhiChu)
33 {
34 try
35 {
36 Models.CauHinhHeThongMod cauHinhHeThong = new Models.CauHinhHeThongMod(_KhoaChinh, _GiaTri, _TrangThai, _GhiChu);
37 return cauHinhHeThong.UpdateCauHinhHeThong();
38 }
39 catch
40 {
41 return 0;
42 }
43
44 }
45
46 // Method Delete
47 public static int DeleteCauHinhHeThong(string _KhoaChinh)
48 {
49 try
50 {
51 Models.CauHinhHeThongMod cauHinhHeThong = new Models.CauHinhHeThongMod(_KhoaChinh);
52 return cauHinhHeThong.DeleteCauHinhHeThong();
53 }
54 catch
55 {
56 return 0;
57 }
58 }
59
60 //delete du lieu demo
61 public static int DeleteDuLieuDemo(string _KhoaChinh)
62 {
63 try
64 {
65 Models.CauHinhHeThongMod cauHinhHeThong = new Models.CauHinhHeThongMod(_KhoaChinh);
66 return cauHinhHeThong.DeleteDuLieuDemo();
67 }
68 catch
69 {
70 return 0;
71 }
72 }
73
74 //Lây điểm tích lũy theo sdt khách hàng
75 public static DataSet FillDataSet_getAllCauHinhHeThong()
76 {
77 try
78 {
79 Models.CauHinhHeThongMod cauHinhHeThong = new Models.CauHinhHeThongMod();
80 return cauHinhHeThong.FillDataSet_getAllCauHinhHeThong();
81
82 }
83 catch
84 {
85 return null;
86 }
87 }
88
89 //Kieu dataReader
90 public static SqlDataReader DataReader_getAllCauHinh_HT()
91 {
92 try
93 {
94 Models.CauHinhHeThongMod cauHinhHeThong = new Models.CauHinhHeThongMod();
95 return cauHinhHeThong.DataReader_getAllCauHinh_HT();
96
97 }
98 catch
99 {
100 return null;
101 }
102
103 }
104 }
105 }